Data: From 2018-10-01 to 2018-10-18

1. Country Level Flow Map



Note: “Other” is aggregated stats for countries which are not listed

Note: Distance is calulated by geospatial distance based on ip address of share origins and destinations


\[Click \ Pct = \frac{\verb|#| Clicks \ between \ Origins \ and \ Destinations} {\verb|#| Total \ Clicks} \]

Note: Only listed records with click count greater than 5000

The most shares are domestic shares. But US has more inbound clicks from other countries

For clicks origins from Brazil, about 18% of them are clicked by US users

For clicks origins from Germany, about 8% of them are clicked by countries wich are not listed. And 32% of click from “other” countries are from Poland, Austria and Italy

For clicks origins from Australia, about 17% of them are clicked by US users


##    Origins Destinations Inbound click Count Average Distance/km Click Pct
## 1       US           US              480311              811.10     23.99
## 2    Other        Other              449729              294.41     22.46
## 3       DE           DE              161020              173.19      8.04
## 4       IT           IT              145955              214.56      7.29
## 5       FR           FR              112978              200.50      5.64
## 6       BR           BR               81423              320.03      4.07
## 7       ES           ES               79271              290.38      3.96
## 8       GB           GB               63345              147.70      3.16
## 11      CA           CA               52562              312.89      2.63
## 9       NL           NL               46315               53.54      2.31
## 13      CZ           CZ               37571               78.05      1.88
## 12      MX           MX               37152              278.55      1.86
## 10   Other           US               36344             6304.55      1.82
## 14      HU           HU               34596               65.30      1.73
## 16      AU           AU               29628              453.79      1.48
## 15      US        Other               27067             5545.15      1.35
## 17      BR           US               18102             9735.74      0.90
## 21      DE        Other               13981             1767.51      0.70
## 19      CA           US               11126             2736.62      0.56
## 23      FR        Other                9918             2793.57      0.50
## 18      FR           US                9283             8692.09      0.46
## 20      GB           US                8622             7849.41      0.43
## 24      GB        Other                7936             3449.13      0.40
## 27   Other           DE                7203             1820.51      0.36
## 22      AU           US                6552            14178.34      0.33
## 28      IT           DE                6474             1080.52      0.32
## 25      IT           FR                5803              982.75      0.29
## 29   Other           FR                5635             3009.45      0.28
## 26      MX           US                5629             2088.18      0.28
## 30      FR           IT                5545              968.10      0.28
## 31      IT        Other                5158             2537.97      0.26


2. Share Distance Analysis

2.1 Global Result


Note if click count is less than 1000, then set average distance to 0 to avoid biasness from small sample

Average distance is strongly correlated with national land area since most countries have high domestic share click rate

The domestic share click rate for US is 91% which is higher than other country, while UK has relatively low domestic share click rate, but high same region share click rate


##    Origins Inbound count Avg Distance/km Domestic Share Pct Same State Pct
## 1       US        523162         1171.84              91.81          41.51
## 2       DE        182669          454.14              88.15          37.82
## 3       IT        166444          451.00              87.69          32.68
## 4       FR        139651         1004.40              80.90          30.42
## 5       BR        101054         2143.00              80.57          54.70
## 6       ES         87974          743.21              90.11          35.51
## 7       GB         84498         1401.65              74.97          53.66
## 8       CA         68046         1150.47              77.24          61.25
## 9       NL         53061          428.41              87.29          28.76
## 10      MX         43377          606.02              85.65          39.70
## 11      CZ         40289          341.72              93.25          34.17
## 13      AU         38502         3436.98              76.95          51.99
## 14      HU         37849          387.97              91.41          29.80
## 28      NO         35757          546.78              92.36          13.16
## 12      PR         31468         1250.05              62.17          62.17
## 15      IL         27116          363.33              94.05          39.97
## 19      SE         26710          903.75              84.44          28.32
## 17      CH         24878          517.64              81.88          29.59
## 16      CR         23809          157.35              96.09          38.88
## 32      DK         20137          408.25              90.51          24.81


2.2 US Result


Arizona, Connecticut, Washington and Massachusetts have highest average share distance among continental states.

California and Texas have highest local state share click rate.

Midwest states like Wisconsin and Indiana have high domestic share rate but low local state share rate.

Alaska and Hawii have relatively higher local state share rate. 

##    Origins Inbound Click Count Domestic Pct Same State Pct Avg Distance/km
## 1       CA               48483        90.50          68.42         1147.98
## 2       FL               43963        82.88          56.55         1152.03
## 3       TX               36821        91.74          60.92         1012.52
## 4       NY               21515        87.00          50.95         1207.35
## 5       IL               20858        93.93          46.67          889.73
## 6       PA               16744        91.51          42.46         1257.65
## 10      OH               15594        96.72          46.41          838.28
## 8       MI               14913        94.19          56.51          906.44
## 7       GA               14071        92.67          44.79         1123.47
## 9       NC               13699        88.12          35.33         1285.00
## 11      WA               11108        90.83          46.94         1492.99
## 12      NJ               10607        83.32          44.51         1365.90
## 15      AZ                9397        87.12          35.96         1605.78
## 14      MA                9050        89.07          40.80         1428.19
## 13      TN                8929        95.77          38.54         1075.18
## 16      CO                8375        94.05          46.50         1004.95
## 19      MN                8152        92.30          39.50         1302.23
## 18      MD                7920        87.12          41.26         1282.00
## 17      VA                7506        91.10          37.33         1312.90
## 22      OK                6910        97.18          41.53          732.45
## 21      IN                6732        94.92          32.50          908.32
## 20      AL                6630        96.50          31.01         1052.84
## 23      MO                5442        93.22          34.09         1095.32
## 26      UT                5355        91.06          36.51         1418.79
## 25      WI                5136        94.76          36.70          926.65
## 24      SC                5128        90.23          23.79         1124.50
## 27      OR                4972        95.84          43.85          926.61
## 28      NV                4967        91.87          32.84         1179.16
## 29      KY                4068        95.94          29.57         1074.97
## 30      CT                3679        86.08          29.49         1524.35
## 33      LA                3547        92.50          29.72         1017.35
## 31      IA                3485        97.33          30.99          830.51
## 32      NM                3172        96.22          32.31         1041.99
## 34      NE                2580        94.30          29.07          914.37
## 35      AR                2353        95.75          29.41         1094.09
## 40      DC                2086        88.45           6.66         1282.73
## 36      KS                2065        89.93          36.08         1173.67
## 39      ID                1887        93.53          19.61         1354.65
## 38      MS                1786        96.58          36.62         1132.41
## 37      WV                1704        97.89          35.56         1037.09
## 41      RI                1507        89.45          23.95         1087.20
## 44      NH                1103        95.65          35.45         1124.50
## 42      ME                1064        97.09          39.19         1346.94
## 45      DE                1025        95.61          20.39         1284.64
## 46      HI                 975        96.10          51.90         2521.35
## 43      AK                 835        96.77          48.38         2052.76
## 50      WY                 771        99.87          14.66         1215.95
## 47      MT                 623        99.20          29.70         1062.65
## 49      VT                 557        98.20          28.19         1420.43
## 48      SD                 519        96.34          26.59         1096.31
## 51      ND                 409        95.60          24.45         1408.71

3. Transaction product price distribution


\[Percentage = \frac{\verb|#| Transactions \ from \ price \ range} {\verb|#| Total \ Transactions} \]

Self click have higher rate for high product value transactions.


##   price_seg Overall self_click same_last other_click
## 1      free   15.95      11.52     15.64       16.15
## 2     $1-$5   40.57      31.63     40.70       41.02
## 3    $5-$10   14.88      16.11     15.14       14.73
## 4   $10-$20   17.53      22.67     18.05       17.27
## 5   $20-$30    6.23       8.43      6.00        6.11
## 6   $30-$50    2.99       5.48      2.44        2.94
## 7  $50-$100    1.18       2.48      1.26        1.16
## 8     $100+    0.67       1.70      0.76        0.63